<%@ Language=VBScript %> <% domain=trim(LCASE(Request("domain"))) emailname="webmaster@"&domain If session("agentusername")="" Then ef=True ec="授权非法，有可能是超时造成的。" elseif Request("domain")<>"" And RegExpTest("^[\w-]+(\.[\w-]+)*@[\w-]+(\.[\w-]+)+$",emailname)=false then ef=True ec="请检查域名是否正确。" ElseIf not IsNumeric(Request.QueryString ("id")) Then ef=True ec="ID应该是数字！" ElseIf RegExpTest("[^A-Za-z0-9]",Request("username")) Then ef=True ec="用户名中有非法字符！" 'ElseIf RegExpTest("[^A-Za-z0-9]",Request("hostname")) Then ' ef=True ' ec="主机名中有非法字符！" ElseIf RegExpTest("[^A-Za-z0-9]",Request("ftpname")) Then ef=True ec="FTP名中有非法字符！" ElseIf not IsNumeric(Request("ServerlistID")) Then ef=True ec="服务器ID应该是数字！" ElseIf RegExpTest("[^A-Za-z0-9]",Request("Hosttype")) Then ef=True ec="类型中有非法字符！" ElseIf RegExpTest("[^A-Za-z0-9]",Request("beianstatus")) Then ef=True ec="beianstatus中有非法字符！" ElseIf not IsNumeric(Request("id")) Then ef=True ec="产品ID应该是数字！" ElseIf not IsDate(Request("starttime")) and Request("starttime")<>"" Then ef=True ec="请输入合法的日期！" ElseIf not IsDate(Request("endtime")) and Request("endtime")<>"" Then ef=True ec="请输入合法的日期！" ElseIf not IsDate(Request("starttime1")) and Request("starttime1")<>"" Then ef=True ec="请输入合法的日期！" ElseIf not IsDate(Request("endtime1")) and Request("endtime1")<>"" Then ef=True ec="请输入合法的日期！" ElseIf not IsDate(Request("starttime2")) and Request("starttime2")<>"" Then ef=True ec="请输入合法的日期！" ElseIf not IsDate(Request("endtime2")) and Request("endtime2")<>"" Then ef=True ec="请输入合法的日期！" end If if not ef Then If Request("hostname")<>"" then set ComX=server.CreateObject("freehost_com_7i24.FreehostM") hostname=trim(replace(Request("hostname"),"http://","")) if hostname<>"" then hostname=ComX.idntoac_7i24_com(cstr(hostname)) hostnamecheck=replace(hostname,".","") hostnamecheck=replace(hostnamecheck,"xn--","") If RegExpTest("[^A-Za-z0-9--]",hostnamecheck) Then ef=True ec="请输入合法的域名！" end If End if end if if not ef then%> <%session("FreeHostCom").FreeHost_WR("html5")%> 　邮箱管理 <%session("FreeHostCom").FreeHost_WR("html6")%>

"" then%> style="display:"<%end if%>>

开通新邮箱

　用户名：邮箱产品: <% Set conn=Server.CreateObject("ADODB.Connection") conn.Open Application("FreeHostDBlink") Set ds = Server.CreateObject("ADODB.Recordset") Sql="Select * from FreeHost.FreeHost_EmailProductlist where isbydomain='n' and isbyhost='n' and canbyagn='y' and (onlyusebyagn is null or onlyusebyagn='"&session("agentusername")&"') order by id asc" ds.Open Sql,conn,1,1 If ds.Eof Then%> 邮箱产品列表为空. <%else%> <%end if%>

<% if Request("domain")<>"" then Set dspdallemail = Server.CreateObject("ADODB.Recordset") Sql="Select * from FreeHost.FreeHost_Product_ALLEmail where emailname like '%"&Request("domain")&"%'" if Instr(1,sql, ";", 1)>0 or Instr(1,sql, "--", 1)>0 then Response.Write "非法字符！" Response.End end if dspdallemail.Open Sql,conn,1,1 if not dspdallemail.eof then havefind=true end if end if Set dsph = Server.CreateObject("ADODB.Recordset") SQL="Select * from FreeHost.FreeHost_Product_Email where " if Request.QueryString ("username")<>"" then Sql=Sql+"username= '"&trim(Request.QueryString ("username"))&"' and " if Request.QueryString ("id")<>"" then Sql=Sql+"id= '"&trim(Request.QueryString ("id"))&"' and " 'if Request.QueryString ("hostname")<>"" then Sql=Sql+"hostname like '%"&replace(Request.QueryString ("hostname"),"http://","")&"%' and " 'if Request.QueryString ("ftpname")<>"" then Sql=Sql+"ftpname like '%"&trim(Request.QueryString ("ftpname"))&"%' and " 'if Request.QueryString ("ServerlistID")<>"" then Sql=Sql+"ServerlistID = '"&trim(Request.QueryString ("ServerlistID"))&"' and " 'if Request.QueryString ("emailtype")<>"" then Sql=Sql+"emailtype = '"&trim(Request.QueryString ("emailtype"))&"' and " if Request.QueryString ("status")<>"" then if Request.QueryString ("status")="过期暂停" then Sql=Sql+"istest = 'n' and endtime < '"&now&"' and status = '暂停' and " elseif Request.QueryString ("status")="过期未暂停" then Sql=Sql+"istest = 'n' and endtime < '"&now&"' and status = '正常' and " elseif Request.QueryString ("status")="试用过期未暂停" then Sql=Sql+"endtime < '"&now&"' and istest = 'y' and status = '正常' and " elseif Request.QueryString ("status")="试用过期已暂停" then Sql=Sql+"endtime < '"&now&"' and istest = 'y' and status = '暂停' and " elseif Request.QueryString ("status")="试用过期" then Sql=Sql+"endtime < '"&now&"' and istest = 'y' and " elseif Request.QueryString ("status")="试用" then Sql=Sql+"endtime > '"&now&"' and istest = 'y' and " else 'Sql=Sql+"istest = 'n' and status = '"&trim(Request.QueryString ("status"))&"' and " end if end if 'if Request.QueryString ("beianstatus")<>"" and Request.QueryString ("beianstatus")<>"没有备案" then Sql=Sql+"beianstatus = '"&trim(Request.QueryString ("beianstatus"))&"' and " 'if Request.QueryString ("beianstatus")="没有备案" then Sql=Sql+"beianstatus is null and " if Request.QueryString ("starttime2") <>"" then Sql=Sql+"starttime>'"&Request.QUERYSTRING ("starttime1")&"' and starttime<'"&Request.QUERYSTRING ("starttime2")&"' and " if Request.QueryString ("endtime2") <>"" then Sql=Sql+"endtime>'"&Request.QUERYSTRING ("endtime1")&"' and endtime<'"&Request.QUERYSTRING ("endtime2")&"' and " if Request.QueryString ("starttime") <>"" then Sql=Sql+"starttime>'"&Request.QUERYSTRING ("starttime")&"' and " if Request.QueryString ("endtime") <>"" then Sql=Sql+"endtime<'"&Request.QUERYSTRING ("endtime")&"' and " if right(sql,5)=" and " then sql=left(sql,len(sql)-5)&" and (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by id desc" if right(SQL,6)="where " then SQL="Select * from FreeHost.FreeHost_Product_Email where (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by id desc" if Request.QueryString ("op") ="all" then Sql="Select * from FreeHost.FreeHost_Product_Email where (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by id desc" if Request.QueryString ("op") ="pause" then Sql="Select * from FreeHost.FreeHost_Product_Email where endtime<'"&now&"' and (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by endtime desc" if Request.QueryString ("op") ="del" then Sql="Select * from FreeHost.FreeHost_Product_Email where endtime<'"&dateadd("d",-30,now)&"' order by endtime desc" if Request.QueryString ("op") ="willpause" then Sql="Select * from FreeHost.FreeHost_Product_Email where endtime<'"&dateadd("d",30,now)&"' and (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by endtime desc " if Request("domain")<>"" and havefind then Sql="Select * from FreeHost.FreeHost_Product_Email where id="&dspdallemail("PdEID")&" and (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by endtime desc" elseif Request("domain")<>"" and not havefind then Sql="Select * from FreeHost.FreeHost_Product_Email where id=0" end if 'Response.Write sql if Instr(1,sql, ";", 1)>0 or Instr(1,sql, "--", 1)>0 then Response.Write "非法字符！" Response.End end if dsph.PageSize = 25 dsph.Open Sql,conn,1,1 if not dsph.eof then if Request.ServerVariables("QUERY_STRING")<>"" then ask=Split(Request.ServerVariables("QUERY_STRING"), chr(38)&"pn") else ask=Split("freehost=1", "") ask(0)="freehost=lsoft" end if pn=1 if Request.QueryString ("pn")<>"" then pn=Request.QueryString ("pn") If dsph.RecordCount <> 0 Then dsph.AbsolutePage = CLng(pn) if clng(pn)<=10 then begini=1 if dsph.PageCount<=10 then endini=dsph.PageCount else endini=10 end if end if %> <%if clng(pn)<=10 then%>最新 <%for i=begini to endini if clng(pn)=i then%>[<%=i%>]<%else%>[<%=i%>]<%end if%>　<%next%> <%else%>　最新[1]--[10]　　现在是第[<%=pn%>]页　共<%=dsph.PageCount%>页　<%end if%><%If Clng(pn)>1 Then%>上一页<%End If%>|<%If Clng(pn)下一页<%End If%> <%if Request.QueryString ("op") ="" then%>今天新开通 | ">一周新开通 | ">一周到期 | ">30天到期 | 全部<%end if%>

<% For N=1 To dsph.PageSize If dsph.RecordCount=0 Then Exit For %> <% Emailtype=dsph("Emailtype") Set ori_host_name = Server.CreateObject("ADODB.Recordset") Sql="Select id from FreeHost.FreeHost_EmailProductlist where Emailtype='"&dsph("Emailtype")&"'" ori_host_name.Open Sql,conn,1,1 if not ori_host_name.eof then Set newname_host = Server.CreateObject("ADODB.Recordset") Sql="Select Emailtype from FreeHost.FreeHost_EmailProductlist_AGN where agent1='"&session("agentusername")&"' and id='"&ori_host_name("id")&"'" newname_host.Open Sql,conn,1,1 if not newname_host.eof then Emailtype=newname_host("Emailtype") end if%> <% If clng(pn)=dsph.PageCount Then I = dsph.RecordCount - (dsph.PageCount-1) * dsph.PageSize If N=I Then Exit For End If dsph.movenext Next%>

ID	产品类型	用户名	域　名	IP 地址	开通日期	到期日期	状态	操作
<%=dsph("id")%>	<%=Emailtype%> <%if dsph("byhost")<>"" then%> 附属于产品 &id=<%=dsph("byhost")%>"><%=dsph("byhost")%> <%end if%> <%if not isnull(dsph("bydomain")) then%> 购买了" target="_blank">域名(<%=dsph("bydomain")%>)所赠送<%end if%>	"><%=dsph("username")%>	<% Set dspdallemail = Server.CreateObject("ADODB.Recordset") Sql="Select * from FreeHost.FreeHost_Product_ALLEmail where PdEID='"&dsph("id")&"' order by emailname" dspdallemail.Open Sql,conn,1,1 if not dspdallemail.eof then if not isnull(dspdallemail("emailname")) then %><%= replace(dspdallemail("emailname"),Application("admmailname")&"@","")%><% end if end if%>	<% Set dsserver = Server.CreateObject("ADODB.Recordset") Sql="Select * from FreeHost.FreeHost_ServerEmaillist where id='"&dsph ("ServerlistID")&"'" dsserver.Open Sql,conn,1,1 %><%=dsserver("ip")%><%dsserver.close%>	<%=formatdatetime(dsph("starttime"),1)%>	<%=formatdatetime(dsph("endtime"),1)%>	<%if dsph("endtime")>NOW then%> <%if dsph("istest")="y" then%> 试用<%else%> <%=dsph("status")%> <%end if%> <%else%> 过期 <%if dsph("status")="暂停" then%> 暂停 <%end if%> <%end if%>	&go=a">管理

<%if Request.QueryString ("op") ="pause" then%>
马上暂停尚未暂停的过期邮箱的用户>>> <%end if%> <%if Request.QueryString ("op") ="del" then%>
马上删除上面的邮箱>>> <%end if%> <%dsph.close set dsph=nothing else%>

没有相关的记录。

<%end if%>
<%session("FreeHostCom").FreeHost_WR("html7")%> <%end if if ef then Response.Redirect "e.asp?e="&ec end if%>